This Analysis Model is used for: General Ledger. There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.
The main purpose of the General Ledger tabular model is to produce financial statements and visualizations based on IFS General Ledger Transactions in combination with planned values from IFS Business Planning and Budget version. Main reporting tools are Power BI and Excel Pivot Analysis
To be able to use the general ledger model the balances from the different sources have to be mapped into Balance Sets. A balance set is a definition of your financial balances either in the past or in the future. It can be actuals or planning or a combination of both. The model has four pre-defined balance sets for ACT (Actuals), BUD (Budget), CFC (Current Forecast) and NFC (Next Forecast).
Each pre-defined Balance set comes with pre-calculated measures such as YTD (Year To Date), PY (Previous Year) and R12 (Rolling 12).
To take full advantage of the general ledger model it is recommended to set up Accounting Structures for Income Statement and Balance Sheet. By doing so the model will provide dynamic out of the box analysis capabilities.
The analysis can be conducted in Transaction Currency, Accounting Currency or in a common currency named X-rate. X-rate measures translates all balances using the Currency rate types and the connected Currency rates of a selected company. Using the X-rate for example makes it possible to compare actuals (translated with actual rates) with actuals translated with other rates (e.g. with budget or previous year rates).
There are two different methods to translate accounting currency to X-rate. Period based method use the last available rate of the period to translate the period amount and then accumulate the period amounts to get to the YTD amount. YTD based method use the last available rate of the period to translate the YTD amount and then subtract the YTD amount of the previous period to get to the period amount.
To produce more dynamic reports and taking advantage of the large number of pre-defined measures it is recommended to use Switch measures in combination with pre-defined slicers. By doing so it possible to switch between period and YTD amounts and to dynamically switch comparison measure (BUD, CFC, NFC, PY).
Reporting periods are created to provide a common calendar structure regardless of how companies have configured their local accounting calendars and how they are using closing periods. Reporting periods are provided to support operational reporting and analysis with a common view for an organization and across companies.
All measures are based on reporting periods if nothing else is stated. The reporting periods are based on the accounting periods (fiscal year) of one selected company. If companies within the group have different accounting period setup (different fiscal year), those periods need to be mapped to the relevant reporting periods common for all companies. Furthermore, year-end periods can be mapped to a reporting period (normally the last “ordinary” period). This, in combination with the x-rate functionality, means the income statement can be analyzed on aggregated level (sub-group or group) without running it through a consolidation tool - even when companies within the group uses different fiscal years.
The reporting period measures can also be used to analyze the balance sheet. Please note though, that to fully automate multi-company analysis of balance sheet year-to-date balances where companies within the group uses different fiscal years the period mapping functionality in IFS group consolidation is recommended.
In some cases, it is relevant to do reporting and analysis according to the local accounting calendar used in a company, e.g. when it is different to the reporting calendar or for more detailed analysis of the balance sheet.
To analyze the income statement according to the accounting calendar the accounting period dimension can be used. However, since many of the calculated measures are based on the reporting period calendar (such as Opening Balances and Year to date, previous year etc.) not all measures can be analyzed combination with the accounting calendar.
Most suitable for this type of analysis is the basic period measures for ACT, BUD, CFC and NFC.
The balance sheet can also be analyzed using the accounting periods, but for this purpose, specific accounting period measures (separate folder) have been created. The benefit when using these measures is that it is possible to display period 0 (the opening balance period) separately in for example a Power BI matrix visualization. It also adds the possibility to correctly display YTD balances for accounting calendars not equal to the Reporting Calendar used in the Analysis model. Furthermore, these measures can be used for multi-company analysis as long as the selected companies in the report/analysis use the same accounting calendar and the same accounting currency.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| BUSINESS PLANNING MEASURES | FACT_PLAN_TRANS_VALID_PQ_BI | FACT_PLAN_TRANS_VALID_PQ | On Line |
| GL ANALYSIS MEASURES | FACT_GL_ANALYSIS_PQ_BI | FACT_GL_ANALYSIS_PQ | On Line |
| IL ANALYSIS MEASURES | FACT_IL_ANALYSIS_PQ_BI | FACT_INTERNAL_LEDGER_ANALYSIS | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
The GL model has two main end user sources that support standard GL analysis as well as detailed analysis of planning and budgeting:
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| CURRENCY CODE X-RATE 1 | DIM_CURRENCY_CODE_XRATE_PQ_BI | DIM_CURRENCY_CODE_XRATE_PQ | On Line |
| CURRENCY CODE X-RATE 2 | DIM_CURRENCY_CODE_XRATE_PQ_BI | DIM_CURRENCY_CODE_XRATE_PQ | On Line |
| RATE TYPE X-RATE 1 | DIM_CURR_RATE_TYPE_XRATE_PQ_BI | DIM_CURR_RATE_TYPE_XRATE_PQ | On Line |
| RATE TYPE X-RATE 2 | DIM_CURR_RATE_TYPE_XRATE_PQ_BI | DIM_CURR_RATE_TYPE_XRATE_PQ | On Line |
| ACCOUNTING PROJECT | DIM_ACCOUNTING_PROJECT_BI | DIM_ACCOUNTING_PROJECT | On Line |
| BUSINESS PLAN | DIM_BUSINESS_PLAN_BI | DIM_BUSINESS_PLAN | On Line |
| CODE M | DIM_CODE_M_BI | DIM_CODE_M | On Line |
| CODE N | DIM_CODE_N_BI | DIM_CODE_N | On Line |
| CODE O | DIM_CODE_O_BI | DIM_CODE_O | On Line |
| CODE P | DIM_CODE_P_BI | DIM_CODE_P | On Line |
| CODE Q | DIM_CODE_Q_BI | DIM_CODE_Q | On Line |
| CODE R | DIM_CODE_R_BI | DIM_CODE_R | On Line |
| CODE S | DIM_CODE_S_BI | DIM_CODE_S | On Line |
| CODE T | DIM_CODE_T_BI | DIM_CODE_T | On Line |
| CODE K COUNTERPART ONE | DIM_COUNTER_PART_ONE_BI | DIM_COUNTER_PART_ONE | On Line |
| CODE L COUNTERPART TWO | DIM_COUNTER_PART_TWO_BI | DIM_COUNTER_PART_TWO | On Line |
| PLANNING UNIT | DIM_PLANNING_UNIT_BI | DIM_PLANNING_UNIT | On Line |
| ACCOUNTING PERIOD | DIM_ACCOUNTING_PERIOD_BI | DIM_ACCOUNTING_PERIOD | On Line |
| CURRENCY CODE | DIM_CURRENCY_CODE_BI | DIM_CURRENCY_CODE | On Line |
| VOUCHER TYPE | DIM_VOUCHER_TYPE_BI | DIM_VOUCHER_TYPE | On Line |
| ACCOUNT ATTRIBUTE 1 | DIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TC | N/A | |
| CODE B ATTRIBUTE 1 | DIM_ACC_ATTR_BIA,LUP_ACC_ATTRIBUTE_TC | N/A | |
| MEASURE LIST ACTUAL | N/A | N/A | |
| MEASURE LIST COMPARISON | N/A | N/A | |
| SWITCH COMPARISON MEASURE | N/A | N/A | |
| SWITCH CURRENCY TYPE | N/A | N/A | |
| SWITCH DISPLAY UNIT | N/A | N/A | |
| SWITCH TIME PERSPECTIVE | N/A | N/A | |
| COMPANY STRUCTURE 1 | COMPANY_STRUCTURE_ITEM_BIA,LUP_COMP_STRUCTURE_TC | N/A | |
| COUNTERPART STRUCTURE 1 | COUNTERPART_STRUCTURE_ITEM_BIA,LUP_GL_COMP_STRUCT_TC | N/A | |
| COUNTERPART GL | DIM_COUNTERPART_GL_BI | DIM_COUNTERPART_GL | On Line |
| INTERCOMPANY PAIRS | DIM_INTERCOMPANY_MAPPING_BI | DIM_INTERCOMPANY_MAPPING | On Line |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| BUSINESS PLANNING | FACT_PLAN_TRANS_VALID_PQ_BI | FACT_PLAN_TRANS_VALID_PQ | On Line |
| CODE B | DIM_ACC_STRUCT_CODE_B_PQ_BI | DIM_ACC_STRUCT_CODE_B_PQ | On Line |
| CODE C | DIM_ACC_STRUCT_CODE_C_PQ_BI | DIM_ACC_STRUCT_CODE_C_PQ | On Line |
| CODE D | DIM_ACC_STRUCT_CODE_D_PQ_BI | DIM_ACC_STRUCT_CODE_D_PQ | On Line |
| CODE E | DIM_ACC_STRUCT_CODE_E_PQ_BI | DIM_ACC_STRUCT_CODE_E_PQ | On Line |
| CODE F | DIM_ACC_STRUCT_CODE_F_PQ_BI | DIM_ACC_STRUCT_CODE_F_PQ | On Line |
| CODE G | DIM_ACC_STRUCT_CODE_G_PQ_BI | DIM_ACC_STRUCT_CODE_G_PQ | On Line |
| CODE H | DIM_ACC_STRUCT_CODE_H_PQ_BI | DIM_ACC_STRUCT_CODE_H_PQ | On Line |
| CODE I | DIM_ACC_STRUCT_CODE_I_PQ_BI | DIM_ACC_STRUCT_CODE_I_PQ | On Line |
| CODE J | DIM_ACC_STRUCT_CODE_J_PQ_BI | DIM_ACC_STRUCT_CODE_J_PQ | On Line |
| ACCOUNT | DIM_ACC_STRUCT_ACCOUNT_PQ_BI | DIM_ACC_STRUCT_ACCOUNT_PQ | On Line |
| REPORTING PERIOD | DIM_BI_TIME_FINANCE_PQ_BI | DIM_BI_TIME_FINANCE_PQ | On Line |
| IL ANALYSIS | FACT_IL_ANALYSIS_PQ_BI | FACT_INTERNAL_LEDGER_ANALYSIS | On Line |
By defining company structures in IFS Cloud, dynamic out of the box analysis capabilities are provided. To achieve a consolidated view on node level, the node can be selected from the Company Structure and on the same time deselected from the Counterpart Structure. Can configure up to three different Company and Counterpart structures.
By mapping code part values for counterparts to relevant companies in IFS Cloud it is possible to reconcile your intercompany transactions. Use dimension Intercompany Pairs in combination with your intercompany accounts to highlight potential differences at an early stage.
Refer to Technical Documentation for more information.
Refer to Technical Documentation for more information.
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_c_id) - CODE C (ID) |
| GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_d_id) - CODE D (ID) |
| GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 5 (ID) |
| GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 2 (ID) |
| GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 3 (ID) |
| GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 4 (ID) |
| GL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 5 (ID) |
| BUSINESS PLAN RLS (DIM_BUSINESS_PLAN_ID) - BUSINESS PLAN (ID) |
| BUSINESS PLANNING (dim_account_id) - ACCOUNT (ID) |
| BUSINESS PLANNING (dim_business_plan_id) - BUSINESS PLAN (ID) |
| BUSINESS PLANNING (dim_code_b_id) - CODE B (ID) |
| BUSINESS PLANNING (dim_code_c_id) - CODE C (ID) |
| BUSINESS PLANNING (dim_code_d_id) - CODE D (ID) |
| BUSINESS PLANNING (dim_code_e_id) - CODE E (ID) |
| BUSINESS PLANNING (dim_code_f_id) - CODE F (ID) |
| BUSINESS PLANNING (dim_code_g_id) - CODE G (ID) |
| BUSINESS PLANNING (dim_code_h_id) - CODE H (ID) |
| BUSINESS PLANNING (dim_code_i_id) - CODE I (ID) |
| BUSINESS PLANNING (dim_code_j_id) - CODE J (ID) |
| BUSINESS PLANNING (dim_code_m_id) - CODE M (ID) |
| BUSINESS PLANNING (dim_code_n_id) - CODE N (ID) |
| BUSINESS PLANNING (dim_code_o_id) - CODE O (ID) |
| BUSINESS PLANNING (dim_code_p_id) - CODE P (ID) |
| BUSINESS PLANNING (dim_code_q_id) - CODE Q (ID) |
| BUSINESS PLANNING (dim_code_r_id) - CODE R (ID) |
| BUSINESS PLANNING (dim_code_s_id) - CODE S (ID) |
| BUSINESS PLANNING (dim_code_t_id) - CODE T (ID) |
| BUSINESS PLANNING (dim_company_id) - COMPANY STRUCTURE 1 (Company) |
| BUSINESS PLANNING (dim_company_id) - COMPANY STRUCTURE 2 (Company) |
| BUSINESS PLANNING (dim_company_id) - COMPANY STRUCTURE 3 (Company) |
| BUSINESS PLANNING (dim_company_id) - COMPANY (ID) |
| BUSINESS PLANNING (dim_counter_part_one_id) - CODE K COUNTERPART ONE (ID) |
| BUSINESS PLANNING (dim_counter_part_two_id) - CODE L COUNTERPART TWO (ID) |
| BUSINESS PLANNING (dim_currency_code_id) - CURRENCY CODE (ID) |
| BUSINESS PLANNING (dim_planning_unit_id) - PLANNING STRUCTURE (ID) |
| BUSINESS PLANNING (dim_planning_unit_id) - PLANNING UNIT (ID) |
| BUSINESS PLANNING (dim_posting_comb_comp_id) - CODE COMP COMBINATION (ID) |
| BUSINESS PLANNING (dim_reporting_date_id) - REPORTING PERIOD (ID) |
| CODESTRING COMBINATION RLS (POST_COMB_COMP_ID) - CODE COMP COMBINATION (ID) |
| GL ANALYSIS (company_base_currency) - REPORTING FROM CURRENCY 2 (Currency Code) |
| GL ANALYSIS (company_base_currency) - REPORTING FROM CURRENCY (Currency Code) |
| GL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 1 (ID) |
| GL ANALYSIS (dim_account_id) - ACCOUNT (ID) |
| GL ANALYSIS (dim_accounting_period_id) - ACCOUNTING PERIOD (ID) |
| GL ANALYSIS (dim_accounting_project_id) - ACCOUNTING PROJECT (ID) |
| GL ANALYSIS (dim_code_b_id) - CODE B (ID) |
| GL ANALYSIS (dim_code_e_id) - CODE E (ID) |
| GL ANALYSIS (dim_code_f_id) - CODE F (ID) |
| GL ANALYSIS (dim_code_g_id) - CODE G (ID) |
| GL ANALYSIS (dim_code_h_id) - CODE H (ID) |
| GL ANALYSIS (dim_code_i_id) - CODE I (ID) |
| GL ANALYSIS (dim_code_j_id) - CODE J (ID) |
| GL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 1 (Company) |
| GL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 2 (Company) |
| GL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 3 (Company) |
| GL ANALYSIS (dim_company_id) - COMPANY (ID) |
| GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART GL (ID) |
| GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART STRUCTURE 1 (Counterpart) |
| GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART STRUCTURE 2 (Counterpart) |
| GL ANALYSIS (dim_counterpart_gl_id) - COUNTERPART STRUCTURE 3 (Counterpart) |
| GL ANALYSIS (dim_currency_code_id) - CURRENCY CODE (ID) |
| GL ANALYSIS (dim_intercompany_pairs_id) - INTERCOMPANY PAIRS (ID) |
| GL ANALYSIS (dim_posting_comb_comp_id) - CODE COMP COMBINATION (ID) |
| GL ANALYSIS (dim_reporting_date_id) - REPORTING PERIOD (ID) |
| GL ANALYSIS (dim_voucher_type_id) - VOUCHER TYPE (ID) |
| GL COMPANY RLS (COMPANY) - COMPANY (ID) |
| MEASURE LIST ACTUAL (Dim Currency Type Id) - SWITCH CURRENCY TYPE (Row Index) |
| MEASURE LIST ACTUAL (Dim Time Perspective Id) - SWITCH TIME PERSPECTIVE (Row Index) |
| MEASURE LIST COMPARISON (Dim Comparison Id) - SWITCH COMPARISON MEASURE (Row Index) |
| MEASURE LIST COMPARISON (Dim Currency Type Id) - SWITCH CURRENCY TYPE (Row Index) |
| MEASURE LIST COMPARISON (Dim Time Perspective Id) - SWITCH TIME PERSPECTIVE (Row Index) |
| PLANNING UNIT RLS (DIM_PLANNING_UNIT_ID) - PLANNING UNIT (ID) |
| X-RATES 1 (CURRENCY_RATE_TYPE_KEY) - RATE TYPE X-RATE 1 (Rate Type Code X-Rate 1) |
| X-RATES 1 (FROMCURRENCY) - REPORTING FROM CURRENCY (Currency Code) |
| X-RATES 1 (TOCURRENCY) - CURRENCY CODE X-RATE 1 (Currency Code X-Rate 1) |
| X-RATES 2 (CURRENCY_RATE_TYPE_KEY) - RATE TYPE X-RATE 2 (Rate Type Code X-Rate 2) |
| X-RATES 2 (FROMCURRENCY) - REPORTING FROM CURRENCY 2 (Currency Code) |
| X-RATES 2 (TOCURRENCY) - CURRENCY CODE X-RATE 2 (Currency Code X-Rate 2) |
| X-RATES 1 (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID) |
| X-RATES 2 (CURRENCY_RATE_DATE_ID) - REPORTING PERIOD (ID) |
| IL ANALYSIS (dim_account_id) - ACCOUNT (ID) |
| IL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_account_id) - ACCOUNT ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_accounting_period_id) - ACCOUNTING PERIOD (ID) |
| IL ANALYSIS (dim_accounting_project_id) - ACCOUNTING PROJECT (ID) |
| IL ANALYSIS (dim_code_b_id) - CODE B (ID) |
| IL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_b_id) - CODE B ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_c_id) - CODE C (ID) |
| IL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_c_id) - CODE C ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_d_id) - CODE D (ID) |
| IL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_d_id) - CODE D ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_e_id) - CODE E (ID) |
| IL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_e_id) - CODE E ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_f_id) - CODE F (ID) |
| IL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_f_id) - CODE F ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_g_id) - CODE G (ID) |
| IL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_g_id) - CODE G ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_h_id) - CODE H (ID) |
| IL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_h_id) - CODE H ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_i_id) - CODE I (ID) |
| IL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_i_id) - CODE I ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_code_j_id) - CODE J (ID) |
| IL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 1 (ID) |
| IL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 2 (ID) |
| IL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 3 (ID) |
| IL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 4 (ID) |
| IL ANALYSIS (dim_code_j_id) - CODE J ATTRIBUTE 5 (ID) |
| IL ANALYSIS (dim_company_id) - COMPANY (ID) |
| IL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 1 (Company) |
| IL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 2 (Company) |
| IL ANALYSIS (dim_company_id) - COMPANY STRUCTURE 3 (Company) |
| IL ANALYSIS (dim_currency_code_id) - CURRENCY CODE (ID) |
| IL ANALYSIS (dim_reporting_date_id) - REPORTING PERIOD (ID) |
| IL ANALYSIS (dim_voucher_type_id) - VOUCHER TYPE (ID) |
| IL ANALYSIS (company_base_currency) - REPORTING FROM CURRENCY (Currency Code) |
| IL ANALYSIS (company_base_currency) - REPORTING FROM CURRENCY 2 (Currency Code) |
| CODESTRING COMBINATION IL RLS (POST_COMB_COMP_ID) - CODE COMP COMBINATION IL (ID) |
| IL ANALYSIS (dim_posting_comb_comp_id) - CODE COMP COMBINATION IL (ID) |